CREATE EXTERNAL TABLE IF NOT EXISTS spmi_ods.spmi_transfer_material_relation(
id                                                 bigint                         COMMENT '自增ID',
fee_id                                             bigint                         COMMENT '中转费报价明细ID',
goods_id                                           bigint                         COMMENT '物品类型ID',
goods_name                                         String                         COMMENT '物品类型名称',
goods_code                                         String                         COMMENT '物品类型编码'
)
COMMENT '中转费报价明细-物品类型关系表'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/spmi_ods.db/external/spmi_transfer_material_relation'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);